<?php
/**
 * Application level Controller
 *
 * This file is application-wide controller file. You can put all
 * application-wide controller-related methods here.
 *
 * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 * @link          http://cakephp.org CakePHP(tm) Project
 * @package       app.Controller
 * @since         CakePHP(tm) v 0.2.9
 * @license       http://www.opensource.org/licenses/mit-license.php MIT License
 */

App::uses('AppController', 'Controller');

/**
 * Application Controller
 *
 * Add your application-wide methods in the class below, your controllers
 * will inherit them.
 *
 * @package		app.Controller
 * @link		http://book.cakephp.org/2.0/en/controllers.html#the-app-controller
 */
class UserClicksController extends AppController {
	public $sequence = 'seq_user_click_id';
	public function nextval() {
        $sql = "select seq_user_click_id.nextval from dual";
        $result = $this->UserClick->query($sql);
        return $result;
    }
		public function index() {
		// $data['Member'] = array(
			// 'id' => 4,
			// 'username' => 'loannguyendinh111',
			// 'password' => 'com111',
		// );
		
		// if($this->Member->save($data)){
			// echo 'them thanh cong';
		// }else {
			// echo 'Khong them duoc';
		// }
		// exit;
		$a = $this->nextval();
		$data['UserClick'] = array(
			'id' => $a[0][0]['dual'],
			'ip' => '192.168.1.1111',
			'advgoup_id' => '1',
			'contract_id' => '1',
			
		);
		if($this->UserClick->save($data)) {
			echo '<br />Them thanh cong';
		}else {
			echo '<br />Them that bai';
		}
		// $this->UserClick->find('all');
		
		
	}
}
